﻿
CREATE PROCEDURE [dbo].[proc_Department_GetItem]
	(
		@Id int
	)
AS
	Select
	Id,
	ParentId,
	CompanyId,
	Sort,
	DName,
	bmbh,
	IsNull(ProtectCount,0) AS ProtectCount,
	IsNull(ProtectDays,0) AS ProtectDays
	From Department Where Id=@Id
	RETURN
